
CREATE TABLE [PLAYERS] (
	[TEAM] nvarchar(3) NOT NULL,
	[NO] tinyint NOT NULL,
	[NAME] nvarchar(20) NOT NULL,
	[SURNAME] nvarchar(20) NOT NULL,
	[POS] nvarchar(3) NOT NULL,
	[STATUS] nvarchar(3) NOT NULL,
	[HEIGHT] nvarchar(5) NOT NULL,
	[WEIGHT] int NOT NULL,
	[BIRTHDATE] nvarchar(10) NOT NULL,
	[EXP] tinyint NOT NULL,
	[COLLEGE] nvarchar(30) NOT NULL,
	[REF] nvarchar(100) NULL
);
GO
ALTER TABLE [PLAYERS] ADD CONSTRAINT [PK_PLAYERS] PRIMARY KEY ([SURNAME],[NAME],[TEAM],[NO]);
GO
